FaCodMessageClassDetails

EntityType | Independent
Logical Entity Name | FaCodMessageClassDetails
Default Table Name | FaCodMessageClassDetails
Logical Only | NO
Owner | dbo
Definition |
Note |

FaCodMessageClassDetails Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaCodMessageClassDetailsID |  | INTEGER | NO |
AwardYear |  | CHAR(7) | NO |
Description |  | VARCHAR(200) | NO |
FileName |  | VARCHAR(50) | NO |
FileType |  | VARCHAR(100) | YES |
Import |  | INTEGER | NO |
UserId |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
TS |  | TIMESTAMP/DATE | NO |
ProcessCode |  | VARCHAR(8) | YES |

FaCodMessageClassDetails Keys

Key Name | Key Type | Keys
PK_FaCodMessageClassDetails_FaCodMessageClassDetailsID | PrimaryKey | FaCodMessageClassDetailsID
FaCodMessageClassDetails_UserID_N_N_IDX | Inversion Entry | UserId

FaCodMessageClassDetails Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | One To Zero or More |  |  |  | UserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaCodMessageClassDetails Check Constraints

Check Constraint Name | CheckConstraint

FaCodMessageClassDetails Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaCodMessageClassDetails | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaCodMessageClassDetails | NO |  |  |

FaCodMessageClassDetails Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaCodMessageClassDetails Data Movement Rules

Name | Type | Rule Text/Value